Diagram GP

Defincja diagramu GP

Name

GP

Code

GP

Comment

 


Lista tabel diagramu

Name

Code

Action

Action

CategoryGP

CategoryGP

CategoryGPText

CategoryGPText

DictionaryValue

DictionaryValue

Episode

Episode

ExternalDoctor

ExternalDoctor

ExternalIdentifier

ExternalIdentifier

ExternalOrgUnit

ExternalOrgUnit

GPPatientIdentification

GPPatientIdentification

GPSubscription

GPSubscription

GPSubscriptionStatus

GPSubscriptionStatus

GPSubscriptionStatusText

GPSubscriptionStatusText

GPSubscriptionType

GPSubscriptionType

GPSubscriptionTypeText

GPSubscriptionTypeText

IdentificationType

IdentificationType

IdentificationTypeText

IdentificationTypeText

ImportGPS4SchoolPOZ

ImportGPS4SchoolPOZ

LGPSubscriptionIdentifier

LGPSubscriptionIdentifier

LGPSubscriptionReason

LGPSubscriptionReason

LGPSubscriptionStatus

LGPSubscriptionStatus

LGPSubscrTypePersonnelType

LGPSubscrTypePersonnelType

LPersonnelTypeMHOrgUnit

LPersonnelTypeMHOrgUnit

LPersonPsychExtOrgUnit

LPersonPsychExtOrgUnit

NfzMessage

NfzMessage

Patient

Patient

Person

Person

Personnel

Personnel

PersonnelType

PersonnelType

PersonnelTypeMH

PersonnelTypeMH

PsychiatricData

PsychiatricData

PupilCategory

PupilCategory

PupilCategoryText

PupilCategoryText

School

School

SchoolKind

SchoolKind

SchoolKindText

SchoolKindText


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

I_2

I_2

Person

Personnel

PersonID

 

 

R_641

R_641

Personnel

Personnel

Per_PersonID2

 

 

R_668

R_668

GPSubscriptionType

GPSubscription

GPSubscriptionTypeID

 

 

R_670

R_670

GPSubscriptionType

GPSubscriptionTypeText

GPSubscriptionTypeID

 

 

R_672

R_672

Person

GPSubscription

Per_PersonID

 

 

R_673

R_673

ExternalOrgUnit

GPSubscription

ExternalOrgUnitID

 

 

R_675

R_675

Personnel

GPSubscription

PersonID

 

 

R_676

R_676

ExternalDoctor

GPSubscription

ExternalDoctorID

 

 

R_721

R_721

GPSubscription

LGPSubscriptionIdentifier

GPSubscriptionID

 

 

R_722

R_722

ExternalIdentifier

LGPSubscriptionIdentifier

IdentifierTypeID; ExternalValue

 

 

R_724

R_724

CategoryGP

CategoryGPText

CategoryGPID

 

 

R_725

R_725

CategoryGP

GPSubscription

CategoryGPID

 

 

R_1511

R_1511

GPSubscriptionType

LGPSubscrTypePersonnelType

GPSubscriptionTypeID

 

 

R_1512

R_1512

PersonnelType

LGPSubscrTypePersonnelType

PersonnelTypeID

 

 

R_1603

R_1603

SchoolKind

SchoolKindText

SchoolKindID

 

 

R_1604

R_1604

SchoolKind

School

SchoolKindID

 

 

R_1605

R_1605

PupilCategory

PupilCategoryText

PupilCategoryID

 

 

R_1607

R_1607

PupilCategory

GPSubscription

PupilCategoryID

 

 

R_1608

R_1608

School

GPSubscription

SchoolID

 

 

R_1615

R_1615

IdentificationType

IdentificationTypeText

IdentificationTypeID

 

 

R_1616

R_1616

IdentificationType

GPSubscription

IdentificationTypeID

 

 

R_1683

R_1683

Person

LPersonPsychExtOrgUnit

PersonID

 

 

R_1684

R_1684

DictionaryValue

LPersonPsychExtOrgUnit

DictionaryValueID

 

 

R_1685

R_1685

Episode

PsychiatricData

EpisodeID

 

 

R_1700

R_1700

GPSubscriptionStatus

GPSubscriptionStatusText

GPSubscriptionStatusID

 

 

R_1704

R_1704

GPSubscriptionStatus

GPSubscription

GPSubscriptionStatusID

 

 

R_1950

R_1950

PersonnelTypeMH

ExternalDoctor

PersonnelTypeMHID

 

 

R_7000

R_7000

Person

GPPatientIdentification

PersonID

 

 

R_7001

R_7001

IdentificationType

GPPatientIdentification

IdentificationTypeID

 

 

R_9270

R_9270

Person

LPersonnelTypeMHOrgUnit

PersonID

 

 

R_9271

R_9271

PersonnelTypeMH

LPersonnelTypeMHOrgUnit

PersonnelTypeMHID

 

 

R_10029

R_10029

NfzMessage

LGPSubscriptionStatus

NfzMessageID

 

 

R_10063

R_10063

DictionaryValue

GPSubscription

GPSubscriptionProblemID

 

 

R_10328

R_10328

GPSubscription

LGPSubscriptionReason

GPSubscriptionID

 

 

R_10329

R_10329

GPSubscriptionType

LGPSubscriptionReason

GPSubscriptionTypeID

 

 

R_10330

R_10330

DictionaryValue

LGPSubscriptionReason

Reason